package com.ruoyi.logistic.mapper;

import com.ruoyi.logistic.domain.NetworkFeeSubject;
import com.ruoyi.logistic.domain.dto.NetworkFeeSubjectDto;
import com.ruoyi.logistic.domain.dto.NetworkFeeSubjectDtoTwo;
import com.ruoyi.logistic.domain.vo.NetworkFeeSubjectVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.security.core.parameters.P;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface NetworkFeeSubjectMapper extends BaseMapper<NetworkFeeSubject> {
    //    查询显示
    List<NetworkFeeSubject> search(NetworkFeeSubjectVo vo);

    //    新增科目
    boolean insert(NetworkFeeSubjectDto networkFeeSubject);

    //    批量修改（在线编辑）
//    boolean update(List<NetworkFeeSubject> list);

    //    根据父客户id查询
    List<NetworkFeeSubject> findByParentId(Integer parentId);

    //显示一级科目
    List<NetworkFeeSubject> selectOneLevel();
    //    根据月份查询
    List<NetworkFeeSubject> selectByMonth(
//            @Param("networkNameId") Integer networkNameId,
            String month);
//            @Param("parentId") Integer parentId);

//    查询月份
    List<NetworkFeeSubject> selectMonth();
//    汇总某个二级科目本年金额
    String collectYearAmount(@Param("month") String month,@Param("name") String name);

}
